{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Date_Range","SLOTCOUNT"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Date_Range","index":0,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[[3,1,3,2],[9,1,10,4],[2,1,2,5],[14,6,19,13]]}
[]
[null,"Vision Appointment Wizard",null,null,null,null,"NOTE:"]
[null,"                                                               Patient information anonymised",null,null,null,null,"This will only work if Vision is on DLM485 or above."]
[null,"Enter Appointment Date Range",null,null,null,null,"Excel 2010 - Please \"Enable Content\" if a security Warning is displayed"]
[null,"FROM","TO",null,"Select Slot Status"]
[null,"2018-04-01","2018-04-30",null,"Booked appointments only",null,"Excel 2007 - Please enable both Macros... and Data Connections"]
[null,null,null,null,null,null,"Excel 2003 - If macros are disabled you will need to enable them via Tools menu > Macro > Security"]
[null,null,null,null,null,null,null,"On the Security Level tab > Select Medium. Then select the Trusted Publishers tab and tick \"Trust access to Visual Basic Project\""]
[null,null,null,null,null,null,null,"Click OK to close the Security window > Close Excel > Reopen this workbook and select \"Enable Macros\""]
[null,"This will import all appointment data within the date range set"]
[null,null,null,null,null,null,"Written by: Bradley Sieve"]
[null," It with not include any patient identifiable data",null,null,null,null,"Last updated: 01/05/2018 - v1.0"]
[]
[null,null,null,null,null,null,"Disclaimer"]
[null,null,null,null,null,null,"In using this Microsoft Excel report you hereby acknowledge that the software cannot be guaranteed error free and may also be subject to how data is being recorded by your practice, and further acknowledge that the existence of any such errors shall not make Vision responsible for any actions you carry out based on these results."]

{"sheet":"SLOTCOUNT","index":1,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["Free slots only"]
["Booked appointments only"]
["Unavailable slots only"]
["All the above"]
[null,null,"Cancelled appointments only"]
[null,null,"Current Clipnote appointments"]